Edinburgh’s road network

Edinburgh’s implementation zones

Edinburgh’s control zones

Time series analysis

##   Accident_Index nearest_line_id snap_dist
## 1  2013950000001            7250  7.417141
## 2  2013950000002            3316  2.317027
## 3  2013950000003            7395  3.630414
## 4  2013950000007            7250  1.462080
## 5  2013950000010            3323  2.847000
## 7  2013950000548            2862  2.357638

Mapping accidents with roads: 2013/2014

##                    LAYER Accident_Index
## 1 20mph existing streets            159
## 2    20mph local streets            172
## 3     20mph main streets            381
## 4                  30mph            259
## 5        Part time 20mph              6
##   Speed_limit Accident_Index
## 1          20             49
## 2          30            928

Mapping accidents with roads: 2014/2015

##                    LAYER Accident_Index
## 1 20mph existing streets            112
## 2    20mph local streets            142
## 3     20mph main streets            368
## 4                  30mph            237
## 5        Part time 20mph              5
##   Speed_limit Accident_Index
## 1          20             31
## 2          30            833

Mapping accidents with roads: 2015/2016

##                    LAYER Accident_Index
## 1 20mph existing streets            117
## 2    20mph local streets            158
## 3     20mph main streets            332
## 4                  30mph            253
## 5        Part time 20mph              6
##   Speed_limit Accident_Index
## 1          20             39
## 2          30            827

Mapping accidents with roads: 2018/2019

##                    LAYER Accident_Index
## 1 20mph existing streets             36
## 2    20mph local streets             54
## 3     20mph main streets             98
## 4                  30mph             80
## 5        Part time 20mph              1
##   Speed_limit Accident_Index
## 1          20            168
## 2          30            101

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            393
## 2    20mph local streets            479
## 3     20mph main streets           1092
## 4                  30mph            757
## 5        Part time 20mph             17
##   Speed_limit Accident_Index
## 1          20            121
## 2          30           2617

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets             99
## 2    20mph local streets            139
## 3     20mph main streets            275
## 4                  30mph            220
## 5        Part time 20mph              8
##   Speed_limit Accident_Index
## 1          20            456
## 2          30            285

Output column: Layer

##     ID Speed_limit        Y
## 1 2315          30 55.94357
## 2 1504          30 55.94357
## 3 2183          30 55.90697
## 4  838          30 55.95275
## 5 3301          20 55.95278
## 6 3043          20 55.92521

Table: Average annual road traffic collision rates in the city of Edinburgh

Table 1: Average annual road traffic collision rates in the city of Edinburgh (council data)
collisions pre-20mph ( 2013 / 2016 - 3 years ) collisions post-20mph ( 2018 / 2019 - 16 months ) rate pre-20mph rate post-20mph diff in rates = pre - post Perc.diff.rates = (pre - post) / pre * 100
Streets stayed
at 30mph 757 220 252.33 165.41 86.92 34
at 20mph 393 99 131.00 74.44 56.56 43
Part time 20mph : a traffic calming measure in specific hours per day. e.g outside of schools, at the start and end of the school day 17 8 5.67 6.02 -0.35 -6
Streets changed
at 30mph changed to 20mph 1571 414 523.67 311.28 212.39 41
All streets
All streets 2738 741 912.67 557.14 355.53 39
Note:
1 All accidents at 20mph, 30mph
Table 2: Average annual road traffic collision rates in the city of Edinburgh (police)
Type collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
Streets at 20mph 121 456 40.33 350.77 -310.44 -770
Streets at 30mph 2617 285 872.33 219.23 653.10 75
All streets 2738 741 912.67 570.00 342.67 38

Effect estimate

Total number of collisions in the city of Edinburgh
Tax year 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19
Annual number of collisions 977 864 897 Intervention years 741
Rate per year 977 864 897 557.14
% reduction in collisions 35.08
Calculations
A + B + C / 3 912.67
A - B / A 12.00
B - C / B -4.00
Unadjusted_estimate 39.00
Secular_trend 4.00
Note:
1 A : accidents 2013/14 ( 1 year )
2 B : accidents 2014/15 ( 1 year )
3 C : accidents 2015/16 ( 1 year )
4 D : accidents 2018/19 ( 16 months )

Data used for the implementation and control zones (2013-2018)

Mapping accidents with implementation zones : 2013

Mapping accidents with implementation zones: 2014

Mapping accidents with implementation zones: 2015

Mapping accidents with implementation zones: 2016

Mapping accidents with implementation zones: 2017

Mapping accidents with implementation zones: 2018

Output column: Implementation Zone

##   Accident_Index Speed_limit LAYER
## 1  2016950000001          30  <NA>
## 2  2016950000003          30  <NA>
## 3  2016950000004          20  <NA>
## 4  2016950000007          20  <NA>
## 5  2016950000047          30  <NA>
## 6  2016950000111          30  <NA>

Table: Average annual road traffic collision rates in the city of Edinburgh per implementation zone

Table 3: Average annual road traffic collision rates in the city of Edinburgh per implementation zone
Implementation zone collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
1a 470 315 156.67 121.15 35.52 23
1b 65 55 21.67 21.15 0.52 2
2 669 261 223.00 130.50 92.50 41
3 836 378 278.67 189.00 89.67 32
4 179 67 59.67 44.67 15.00 25
5 272 76 90.67 50.67 40.00 44
6 205 34 68.33 37.78 30.55 45
All zones 2696 925 898.67 355.77 542.90 60

Control zone 1a:City center –> George St/Harbour, Aberdeen

## [1] 70

Control zone 1b:Rural west –> Tay Bridgehead & St Andrews

## [1] 43

Control zone 3:South central –> Dundee

## [1] 280

Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West

## [1] 141

Control zone 5:West –> Glasgow Kelvin

## [1] 508

Control zone 6:South –> Paisley

## [1] 165

Updated dataset for Edinburgh

##   Accident_Index LAYER Shape_Area ImplementationZone
## 1  2016950000001  <NA>   17174685                  2
## 2  2016950000003  <NA>   17174685                  2
## 3  2016950000004  <NA>   17174685                  2
## 4  2016950000007  <NA>    3385564                  1
## 5  2016950000047  <NA>   29369816                  3
## 6  2016950000111  <NA>   29369816                  3